select distinct object_name(c.id) + '.' + c.name + ' (' + spt.type_name + ')' 
from syscolumns c inner join master..spt_datatype_info spt on c.xtype = spt.ss_dtype
where xtype in (34,35,99)
and objectproperty(c.id,'IsUserTable') = 1
order by object_name(c.id) + '.' + c.name + ' (' + spt.type_name + ')'

--select * from master..spt_datatype_info